package com.ymttest.database.sharding.db.sharding.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class OrderExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public OrderExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andOrderIdIsNull() {
            addCriterion("order_id is null");
            return (Criteria) this;
        }

        public Criteria andOrderIdIsNotNull() {
            addCriterion("order_id is not null");
            return (Criteria) this;
        }

        public Criteria andOrderIdEqualTo(Long value) {
            addCriterion("order_id =", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotEqualTo(Long value) {
            addCriterion("order_id <>", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThan(Long value) {
            addCriterion("order_id >", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("order_id >=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThan(Long value) {
            addCriterion("order_id <", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("order_id <=", value, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdIn(List<Long> values) {
            addCriterion("order_id in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotIn(List<Long> values) {
            addCriterion("order_id not in", values, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdBetween(Long value1, Long value2) {
            addCriterion("order_id between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("order_id not between", value1, value2, "orderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdIsNull() {
            addCriterion("main_order_id is null");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdIsNotNull() {
            addCriterion("main_order_id is not null");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdEqualTo(Long value) {
            addCriterion("main_order_id =", value, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdNotEqualTo(Long value) {
            addCriterion("main_order_id <>", value, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdGreaterThan(Long value) {
            addCriterion("main_order_id >", value, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdGreaterThanOrEqualTo(Long value) {
            addCriterion("main_order_id >=", value, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdLessThan(Long value) {
            addCriterion("main_order_id <", value, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdLessThanOrEqualTo(Long value) {
            addCriterion("main_order_id <=", value, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdIn(List<Long> values) {
            addCriterion("main_order_id in", values, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdNotIn(List<Long> values) {
            addCriterion("main_order_id not in", values, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdBetween(Long value1, Long value2) {
            addCriterion("main_order_id between", value1, value2, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andMainOrderIdNotBetween(Long value1, Long value2) {
            addCriterion("main_order_id not between", value1, value2, "mainOrderId");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNull() {
            addCriterion("user_id is null");
            return (Criteria) this;
        }

        public Criteria andUserIdIsNotNull() {
            addCriterion("user_id is not null");
            return (Criteria) this;
        }

        public Criteria andUserIdEqualTo(Long value) {
            addCriterion("user_id =", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotEqualTo(Long value) {
            addCriterion("user_id <>", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThan(Long value) {
            addCriterion("user_id >", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdGreaterThanOrEqualTo(Long value) {
            addCriterion("user_id >=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThan(Long value) {
            addCriterion("user_id <", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdLessThanOrEqualTo(Long value) {
            addCriterion("user_id <=", value, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdIn(List<Long> values) {
            addCriterion("user_id in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotIn(List<Long> values) {
            addCriterion("user_id not in", values, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdBetween(Long value1, Long value2) {
            addCriterion("user_id between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andUserIdNotBetween(Long value1, Long value2) {
            addCriterion("user_id not between", value1, value2, "userId");
            return (Criteria) this;
        }

        public Criteria andSellerIdIsNull() {
            addCriterion("seller_id is null");
            return (Criteria) this;
        }

        public Criteria andSellerIdIsNotNull() {
            addCriterion("seller_id is not null");
            return (Criteria) this;
        }

        public Criteria andSellerIdEqualTo(Long value) {
            addCriterion("seller_id =", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdNotEqualTo(Long value) {
            addCriterion("seller_id <>", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdGreaterThan(Long value) {
            addCriterion("seller_id >", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdGreaterThanOrEqualTo(Long value) {
            addCriterion("seller_id >=", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdLessThan(Long value) {
            addCriterion("seller_id <", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdLessThanOrEqualTo(Long value) {
            addCriterion("seller_id <=", value, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdIn(List<Long> values) {
            addCriterion("seller_id in", values, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdNotIn(List<Long> values) {
            addCriterion("seller_id not in", values, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdBetween(Long value1, Long value2) {
            addCriterion("seller_id between", value1, value2, "sellerId");
            return (Criteria) this;
        }

        public Criteria andSellerIdNotBetween(Long value1, Long value2) {
            addCriterion("seller_id not between", value1, value2, "sellerId");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNull() {
            addCriterion("order_status is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIsNotNull() {
            addCriterion("order_status is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusEqualTo(Integer value) {
            addCriterion("order_status =", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotEqualTo(Integer value) {
            addCriterion("order_status <>", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThan(Integer value) {
            addCriterion("order_status >", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_status >=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThan(Integer value) {
            addCriterion("order_status <", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusLessThanOrEqualTo(Integer value) {
            addCriterion("order_status <=", value, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusIn(List<Integer> values) {
            addCriterion("order_status in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotIn(List<Integer> values) {
            addCriterion("order_status not in", values, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusBetween(Integer value1, Integer value2) {
            addCriterion("order_status between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("order_status not between", value1, value2, "orderStatus");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoIsNull() {
            addCriterion("order_status_memo is null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoIsNotNull() {
            addCriterion("order_status_memo is not null");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoEqualTo(Integer value) {
            addCriterion("order_status_memo =", value, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoNotEqualTo(Integer value) {
            addCriterion("order_status_memo <>", value, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoGreaterThan(Integer value) {
            addCriterion("order_status_memo >", value, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoGreaterThanOrEqualTo(Integer value) {
            addCriterion("order_status_memo >=", value, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoLessThan(Integer value) {
            addCriterion("order_status_memo <", value, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoLessThanOrEqualTo(Integer value) {
            addCriterion("order_status_memo <=", value, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoIn(List<Integer> values) {
            addCriterion("order_status_memo in", values, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoNotIn(List<Integer> values) {
            addCriterion("order_status_memo not in", values, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoBetween(Integer value1, Integer value2) {
            addCriterion("order_status_memo between", value1, value2, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andOrderStatusMemoNotBetween(Integer value1, Integer value2) {
            addCriterion("order_status_memo not between", value1, value2, "orderStatusMemo");
            return (Criteria) this;
        }

        public Criteria andPaymentIdIsNull() {
            addCriterion("payment_id is null");
            return (Criteria) this;
        }

        public Criteria andPaymentIdIsNotNull() {
            addCriterion("payment_id is not null");
            return (Criteria) this;
        }

        public Criteria andPaymentIdEqualTo(Long value) {
            addCriterion("payment_id =", value, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdNotEqualTo(Long value) {
            addCriterion("payment_id <>", value, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdGreaterThan(Long value) {
            addCriterion("payment_id >", value, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdGreaterThanOrEqualTo(Long value) {
            addCriterion("payment_id >=", value, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdLessThan(Long value) {
            addCriterion("payment_id <", value, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdLessThanOrEqualTo(Long value) {
            addCriterion("payment_id <=", value, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdIn(List<Long> values) {
            addCriterion("payment_id in", values, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdNotIn(List<Long> values) {
            addCriterion("payment_id not in", values, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdBetween(Long value1, Long value2) {
            addCriterion("payment_id between", value1, value2, "paymentId");
            return (Criteria) this;
        }

        public Criteria andPaymentIdNotBetween(Long value1, Long value2) {
            addCriterion("payment_id not between", value1, value2, "paymentId");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNull() {
            addCriterion("total_price is null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIsNotNull() {
            addCriterion("total_price is not null");
            return (Criteria) this;
        }

        public Criteria andTotalPriceEqualTo(BigDecimal value) {
            addCriterion("total_price =", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotEqualTo(BigDecimal value) {
            addCriterion("total_price <>", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThan(BigDecimal value) {
            addCriterion("total_price >", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("total_price >=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThan(BigDecimal value) {
            addCriterion("total_price <", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("total_price <=", value, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceIn(List<BigDecimal> values) {
            addCriterion("total_price in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotIn(List<BigDecimal> values) {
            addCriterion("total_price not in", values, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_price between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andTotalPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("total_price not between", value1, value2, "totalPrice");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountIsNull() {
            addCriterion("order_discount is null");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountIsNotNull() {
            addCriterion("order_discount is not null");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountEqualTo(BigDecimal value) {
            addCriterion("order_discount =", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotEqualTo(BigDecimal value) {
            addCriterion("order_discount <>", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountGreaterThan(BigDecimal value) {
            addCriterion("order_discount >", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("order_discount >=", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountLessThan(BigDecimal value) {
            addCriterion("order_discount <", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("order_discount <=", value, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountIn(List<BigDecimal> values) {
            addCriterion("order_discount in", values, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotIn(List<BigDecimal> values) {
            addCriterion("order_discount not in", values, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_discount between", value1, value2, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andOrderDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("order_discount not between", value1, value2, "orderDiscount");
            return (Criteria) this;
        }

        public Criteria andFreightIsNull() {
            addCriterion("freight is null");
            return (Criteria) this;
        }

        public Criteria andFreightIsNotNull() {
            addCriterion("freight is not null");
            return (Criteria) this;
        }

        public Criteria andFreightEqualTo(BigDecimal value) {
            addCriterion("freight =", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotEqualTo(BigDecimal value) {
            addCriterion("freight <>", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThan(BigDecimal value) {
            addCriterion("freight >", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("freight >=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThan(BigDecimal value) {
            addCriterion("freight <", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightLessThanOrEqualTo(BigDecimal value) {
            addCriterion("freight <=", value, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightIn(List<BigDecimal> values) {
            addCriterion("freight in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotIn(List<BigDecimal> values) {
            addCriterion("freight not in", values, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("freight between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andFreightNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("freight not between", value1, value2, "freight");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountIsNull() {
            addCriterion("seller_coupon_amount is null");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountIsNotNull() {
            addCriterion("seller_coupon_amount is not null");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountEqualTo(BigDecimal value) {
            addCriterion("seller_coupon_amount =", value, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountNotEqualTo(BigDecimal value) {
            addCriterion("seller_coupon_amount <>", value, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountGreaterThan(BigDecimal value) {
            addCriterion("seller_coupon_amount >", value, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("seller_coupon_amount >=", value, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountLessThan(BigDecimal value) {
            addCriterion("seller_coupon_amount <", value, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("seller_coupon_amount <=", value, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountIn(List<BigDecimal> values) {
            addCriterion("seller_coupon_amount in", values, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountNotIn(List<BigDecimal> values) {
            addCriterion("seller_coupon_amount not in", values, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("seller_coupon_amount between", value1, value2, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("seller_coupon_amount not between", value1, value2, "sellerCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountIsNull() {
            addCriterion("ymt_coupon_amount is null");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountIsNotNull() {
            addCriterion("ymt_coupon_amount is not null");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountEqualTo(BigDecimal value) {
            addCriterion("ymt_coupon_amount =", value, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountNotEqualTo(BigDecimal value) {
            addCriterion("ymt_coupon_amount <>", value, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountGreaterThan(BigDecimal value) {
            addCriterion("ymt_coupon_amount >", value, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ymt_coupon_amount >=", value, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountLessThan(BigDecimal value) {
            addCriterion("ymt_coupon_amount <", value, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ymt_coupon_amount <=", value, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountIn(List<BigDecimal> values) {
            addCriterion("ymt_coupon_amount in", values, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountNotIn(List<BigDecimal> values) {
            addCriterion("ymt_coupon_amount not in", values, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ymt_coupon_amount between", value1, value2, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andYmtCouponAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ymt_coupon_amount not between", value1, value2, "ymtCouponAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountIsNull() {
            addCriterion("promotion_amount is null");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountIsNotNull() {
            addCriterion("promotion_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountEqualTo(BigDecimal value) {
            addCriterion("promotion_amount =", value, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountNotEqualTo(BigDecimal value) {
            addCriterion("promotion_amount <>", value, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountGreaterThan(BigDecimal value) {
            addCriterion("promotion_amount >", value, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("promotion_amount >=", value, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountLessThan(BigDecimal value) {
            addCriterion("promotion_amount <", value, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("promotion_amount <=", value, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountIn(List<BigDecimal> values) {
            addCriterion("promotion_amount in", values, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountNotIn(List<BigDecimal> values) {
            addCriterion("promotion_amount not in", values, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("promotion_amount between", value1, value2, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPromotionAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("promotion_amount not between", value1, value2, "promotionAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountIsNull() {
            addCriterion("payable_amount is null");
            return (Criteria) this;
        }

        public Criteria andPayableAmountIsNotNull() {
            addCriterion("payable_amount is not null");
            return (Criteria) this;
        }

        public Criteria andPayableAmountEqualTo(BigDecimal value) {
            addCriterion("payable_amount =", value, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountNotEqualTo(BigDecimal value) {
            addCriterion("payable_amount <>", value, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountGreaterThan(BigDecimal value) {
            addCriterion("payable_amount >", value, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("payable_amount >=", value, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountLessThan(BigDecimal value) {
            addCriterion("payable_amount <", value, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("payable_amount <=", value, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountIn(List<BigDecimal> values) {
            addCriterion("payable_amount in", values, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountNotIn(List<BigDecimal> values) {
            addCriterion("payable_amount not in", values, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payable_amount between", value1, value2, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andPayableAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("payable_amount not between", value1, value2, "payableAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountIsNull() {
            addCriterion("account_paid_amount is null");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountIsNotNull() {
            addCriterion("account_paid_amount is not null");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountEqualTo(BigDecimal value) {
            addCriterion("account_paid_amount =", value, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountNotEqualTo(BigDecimal value) {
            addCriterion("account_paid_amount <>", value, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountGreaterThan(BigDecimal value) {
            addCriterion("account_paid_amount >", value, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("account_paid_amount >=", value, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountLessThan(BigDecimal value) {
            addCriterion("account_paid_amount <", value, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("account_paid_amount <=", value, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountIn(List<BigDecimal> values) {
            addCriterion("account_paid_amount in", values, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountNotIn(List<BigDecimal> values) {
            addCriterion("account_paid_amount not in", values, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("account_paid_amount between", value1, value2, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andAccountPaidAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("account_paid_amount not between", value1, value2, "accountPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountIsNull() {
            addCriterion("thirdparty_paid_amount is null");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountIsNotNull() {
            addCriterion("thirdparty_paid_amount is not null");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountEqualTo(BigDecimal value) {
            addCriterion("thirdparty_paid_amount =", value, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountNotEqualTo(BigDecimal value) {
            addCriterion("thirdparty_paid_amount <>", value, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountGreaterThan(BigDecimal value) {
            addCriterion("thirdparty_paid_amount >", value, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("thirdparty_paid_amount >=", value, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountLessThan(BigDecimal value) {
            addCriterion("thirdparty_paid_amount <", value, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("thirdparty_paid_amount <=", value, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountIn(List<BigDecimal> values) {
            addCriterion("thirdparty_paid_amount in", values, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountNotIn(List<BigDecimal> values) {
            addCriterion("thirdparty_paid_amount not in", values, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("thirdparty_paid_amount between", value1, value2, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyPaidAmountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("thirdparty_paid_amount not between", value1, value2, "thirdpartyPaidAmount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountIsNull() {
            addCriterion("thirdparty_discount is null");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountIsNotNull() {
            addCriterion("thirdparty_discount is not null");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountEqualTo(BigDecimal value) {
            addCriterion("thirdparty_discount =", value, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountNotEqualTo(BigDecimal value) {
            addCriterion("thirdparty_discount <>", value, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountGreaterThan(BigDecimal value) {
            addCriterion("thirdparty_discount >", value, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("thirdparty_discount >=", value, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountLessThan(BigDecimal value) {
            addCriterion("thirdparty_discount <", value, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountLessThanOrEqualTo(BigDecimal value) {
            addCriterion("thirdparty_discount <=", value, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountIn(List<BigDecimal> values) {
            addCriterion("thirdparty_discount in", values, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountNotIn(List<BigDecimal> values) {
            addCriterion("thirdparty_discount not in", values, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("thirdparty_discount between", value1, value2, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andThirdpartyDiscountNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("thirdparty_discount not between", value1, value2, "thirdpartyDiscount");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeIsNull() {
            addCriterion("seller_coupon_code is null");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeIsNotNull() {
            addCriterion("seller_coupon_code is not null");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeEqualTo(String value) {
            addCriterion("seller_coupon_code =", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeNotEqualTo(String value) {
            addCriterion("seller_coupon_code <>", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeGreaterThan(String value) {
            addCriterion("seller_coupon_code >", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeGreaterThanOrEqualTo(String value) {
            addCriterion("seller_coupon_code >=", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeLessThan(String value) {
            addCriterion("seller_coupon_code <", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeLessThanOrEqualTo(String value) {
            addCriterion("seller_coupon_code <=", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeLike(String value) {
            addCriterion("seller_coupon_code like", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeNotLike(String value) {
            addCriterion("seller_coupon_code not like", value, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeIn(List<String> values) {
            addCriterion("seller_coupon_code in", values, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeNotIn(List<String> values) {
            addCriterion("seller_coupon_code not in", values, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeBetween(String value1, String value2) {
            addCriterion("seller_coupon_code between", value1, value2, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andSellerCouponCodeNotBetween(String value1, String value2) {
            addCriterion("seller_coupon_code not between", value1, value2, "sellerCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeIsNull() {
            addCriterion("ymt_coupon_code is null");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeIsNotNull() {
            addCriterion("ymt_coupon_code is not null");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeEqualTo(String value) {
            addCriterion("ymt_coupon_code =", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeNotEqualTo(String value) {
            addCriterion("ymt_coupon_code <>", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeGreaterThan(String value) {
            addCriterion("ymt_coupon_code >", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeGreaterThanOrEqualTo(String value) {
            addCriterion("ymt_coupon_code >=", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeLessThan(String value) {
            addCriterion("ymt_coupon_code <", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeLessThanOrEqualTo(String value) {
            addCriterion("ymt_coupon_code <=", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeLike(String value) {
            addCriterion("ymt_coupon_code like", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeNotLike(String value) {
            addCriterion("ymt_coupon_code not like", value, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeIn(List<String> values) {
            addCriterion("ymt_coupon_code in", values, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeNotIn(List<String> values) {
            addCriterion("ymt_coupon_code not in", values, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeBetween(String value1, String value2) {
            addCriterion("ymt_coupon_code between", value1, value2, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andYmtCouponCodeNotBetween(String value1, String value2) {
            addCriterion("ymt_coupon_code not between", value1, value2, "ymtCouponCode");
            return (Criteria) this;
        }

        public Criteria andPaidTimeIsNull() {
            addCriterion("paid_time is null");
            return (Criteria) this;
        }

        public Criteria andPaidTimeIsNotNull() {
            addCriterion("paid_time is not null");
            return (Criteria) this;
        }

        public Criteria andPaidTimeEqualTo(Date value) {
            addCriterion("paid_time =", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotEqualTo(Date value) {
            addCriterion("paid_time <>", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeGreaterThan(Date value) {
            addCriterion("paid_time >", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("paid_time >=", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeLessThan(Date value) {
            addCriterion("paid_time <", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeLessThanOrEqualTo(Date value) {
            addCriterion("paid_time <=", value, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeIn(List<Date> values) {
            addCriterion("paid_time in", values, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotIn(List<Date> values) {
            addCriterion("paid_time not in", values, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeBetween(Date value1, Date value2) {
            addCriterion("paid_time between", value1, value2, "paidTime");
            return (Criteria) this;
        }

        public Criteria andPaidTimeNotBetween(Date value1, Date value2) {
            addCriterion("paid_time not between", value1, value2, "paidTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIsNull() {
            addCriterion("accept_time is null");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIsNotNull() {
            addCriterion("accept_time is not null");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeEqualTo(Date value) {
            addCriterion("accept_time =", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotEqualTo(Date value) {
            addCriterion("accept_time <>", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeGreaterThan(Date value) {
            addCriterion("accept_time >", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("accept_time >=", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeLessThan(Date value) {
            addCriterion("accept_time <", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeLessThanOrEqualTo(Date value) {
            addCriterion("accept_time <=", value, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeIn(List<Date> values) {
            addCriterion("accept_time in", values, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotIn(List<Date> values) {
            addCriterion("accept_time not in", values, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeBetween(Date value1, Date value2) {
            addCriterion("accept_time between", value1, value2, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andAcceptTimeNotBetween(Date value1, Date value2) {
            addCriterion("accept_time not between", value1, value2, "acceptTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNull() {
            addCriterion("delivery_time is null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIsNotNull() {
            addCriterion("delivery_time is not null");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeEqualTo(Date value) {
            addCriterion("delivery_time =", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotEqualTo(Date value) {
            addCriterion("delivery_time <>", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThan(Date value) {
            addCriterion("delivery_time >", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("delivery_time >=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThan(Date value) {
            addCriterion("delivery_time <", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeLessThanOrEqualTo(Date value) {
            addCriterion("delivery_time <=", value, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeIn(List<Date> values) {
            addCriterion("delivery_time in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotIn(List<Date> values) {
            addCriterion("delivery_time not in", values, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeBetween(Date value1, Date value2) {
            addCriterion("delivery_time between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andDeliveryTimeNotBetween(Date value1, Date value2) {
            addCriterion("delivery_time not between", value1, value2, "deliveryTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeIsNull() {
            addCriterion("receive_time is null");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeIsNotNull() {
            addCriterion("receive_time is not null");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeEqualTo(Date value) {
            addCriterion("receive_time =", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeNotEqualTo(Date value) {
            addCriterion("receive_time <>", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeGreaterThan(Date value) {
            addCriterion("receive_time >", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("receive_time >=", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeLessThan(Date value) {
            addCriterion("receive_time <", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeLessThanOrEqualTo(Date value) {
            addCriterion("receive_time <=", value, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeIn(List<Date> values) {
            addCriterion("receive_time in", values, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeNotIn(List<Date> values) {
            addCriterion("receive_time not in", values, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeBetween(Date value1, Date value2) {
            addCriterion("receive_time between", value1, value2, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andReceiveTimeNotBetween(Date value1, Date value2) {
            addCriterion("receive_time not between", value1, value2, "receiveTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNull() {
            addCriterion("cancel_time is null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIsNotNull() {
            addCriterion("cancel_time is not null");
            return (Criteria) this;
        }

        public Criteria andCancelTimeEqualTo(Date value) {
            addCriterion("cancel_time =", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotEqualTo(Date value) {
            addCriterion("cancel_time <>", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThan(Date value) {
            addCriterion("cancel_time >", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("cancel_time >=", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThan(Date value) {
            addCriterion("cancel_time <", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeLessThanOrEqualTo(Date value) {
            addCriterion("cancel_time <=", value, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeIn(List<Date> values) {
            addCriterion("cancel_time in", values, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotIn(List<Date> values) {
            addCriterion("cancel_time not in", values, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeBetween(Date value1, Date value2) {
            addCriterion("cancel_time between", value1, value2, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andCancelTimeNotBetween(Date value1, Date value2) {
            addCriterion("cancel_time not between", value1, value2, "cancelTime");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourIsNull() {
            addCriterion("auto_cancel_hour is null");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourIsNotNull() {
            addCriterion("auto_cancel_hour is not null");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourEqualTo(BigDecimal value) {
            addCriterion("auto_cancel_hour =", value, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourNotEqualTo(BigDecimal value) {
            addCriterion("auto_cancel_hour <>", value, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourGreaterThan(BigDecimal value) {
            addCriterion("auto_cancel_hour >", value, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("auto_cancel_hour >=", value, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourLessThan(BigDecimal value) {
            addCriterion("auto_cancel_hour <", value, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourLessThanOrEqualTo(BigDecimal value) {
            addCriterion("auto_cancel_hour <=", value, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourIn(List<BigDecimal> values) {
            addCriterion("auto_cancel_hour in", values, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourNotIn(List<BigDecimal> values) {
            addCriterion("auto_cancel_hour not in", values, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("auto_cancel_hour between", value1, value2, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andAutoCancelHourNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("auto_cancel_hour not between", value1, value2, "autoCancelHour");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryIsNull() {
            addCriterion("xlobo_delivery is null");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryIsNotNull() {
            addCriterion("xlobo_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryEqualTo(Boolean value) {
            addCriterion("xlobo_delivery =", value, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryNotEqualTo(Boolean value) {
            addCriterion("xlobo_delivery <>", value, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryGreaterThan(Boolean value) {
            addCriterion("xlobo_delivery >", value, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryGreaterThanOrEqualTo(Boolean value) {
            addCriterion("xlobo_delivery >=", value, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryLessThan(Boolean value) {
            addCriterion("xlobo_delivery <", value, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryLessThanOrEqualTo(Boolean value) {
            addCriterion("xlobo_delivery <=", value, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryIn(List<Boolean> values) {
            addCriterion("xlobo_delivery in", values, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryNotIn(List<Boolean> values) {
            addCriterion("xlobo_delivery not in", values, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryBetween(Boolean value1, Boolean value2) {
            addCriterion("xlobo_delivery between", value1, value2, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andXloboDeliveryNotBetween(Boolean value1, Boolean value2) {
            addCriterion("xlobo_delivery not between", value1, value2, "xloboDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryIsNull() {
            addCriterion("domestic_delivery is null");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryIsNotNull() {
            addCriterion("domestic_delivery is not null");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryEqualTo(Boolean value) {
            addCriterion("domestic_delivery =", value, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryNotEqualTo(Boolean value) {
            addCriterion("domestic_delivery <>", value, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryGreaterThan(Boolean value) {
            addCriterion("domestic_delivery >", value, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryGreaterThanOrEqualTo(Boolean value) {
            addCriterion("domestic_delivery >=", value, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryLessThan(Boolean value) {
            addCriterion("domestic_delivery <", value, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryLessThanOrEqualTo(Boolean value) {
            addCriterion("domestic_delivery <=", value, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryIn(List<Boolean> values) {
            addCriterion("domestic_delivery in", values, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryNotIn(List<Boolean> values) {
            addCriterion("domestic_delivery not in", values, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryBetween(Boolean value1, Boolean value2) {
            addCriterion("domestic_delivery between", value1, value2, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andDomesticDeliveryNotBetween(Boolean value1, Boolean value2) {
            addCriterion("domestic_delivery not between", value1, value2, "domesticDelivery");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIsNull() {
            addCriterion("logistics_type is null");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIsNotNull() {
            addCriterion("logistics_type is not null");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeEqualTo(Integer value) {
            addCriterion("logistics_type =", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotEqualTo(Integer value) {
            addCriterion("logistics_type <>", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeGreaterThan(Integer value) {
            addCriterion("logistics_type >", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeGreaterThanOrEqualTo(Integer value) {
            addCriterion("logistics_type >=", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeLessThan(Integer value) {
            addCriterion("logistics_type <", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeLessThanOrEqualTo(Integer value) {
            addCriterion("logistics_type <=", value, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeIn(List<Integer> values) {
            addCriterion("logistics_type in", values, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotIn(List<Integer> values) {
            addCriterion("logistics_type not in", values, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeBetween(Integer value1, Integer value2) {
            addCriterion("logistics_type between", value1, value2, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andLogisticsTypeNotBetween(Integer value1, Integer value2) {
            addCriterion("logistics_type not between", value1, value2, "logisticsType");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNull() {
            addCriterion("address_id is null");
            return (Criteria) this;
        }

        public Criteria andAddressIdIsNotNull() {
            addCriterion("address_id is not null");
            return (Criteria) this;
        }

        public Criteria andAddressIdEqualTo(Long value) {
            addCriterion("address_id =", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotEqualTo(Long value) {
            addCriterion("address_id <>", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThan(Long value) {
            addCriterion("address_id >", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdGreaterThanOrEqualTo(Long value) {
            addCriterion("address_id >=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThan(Long value) {
            addCriterion("address_id <", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdLessThanOrEqualTo(Long value) {
            addCriterion("address_id <=", value, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdIn(List<Long> values) {
            addCriterion("address_id in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotIn(List<Long> values) {
            addCriterion("address_id not in", values, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdBetween(Long value1, Long value2) {
            addCriterion("address_id between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andAddressIdNotBetween(Long value1, Long value2) {
            addCriterion("address_id not between", value1, value2, "addressId");
            return (Criteria) this;
        }

        public Criteria andPresaleIsNull() {
            addCriterion("presale is null");
            return (Criteria) this;
        }

        public Criteria andPresaleIsNotNull() {
            addCriterion("presale is not null");
            return (Criteria) this;
        }

        public Criteria andPresaleEqualTo(Boolean value) {
            addCriterion("presale =", value, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleNotEqualTo(Boolean value) {
            addCriterion("presale <>", value, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleGreaterThan(Boolean value) {
            addCriterion("presale >", value, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleGreaterThanOrEqualTo(Boolean value) {
            addCriterion("presale >=", value, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleLessThan(Boolean value) {
            addCriterion("presale <", value, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleLessThanOrEqualTo(Boolean value) {
            addCriterion("presale <=", value, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleIn(List<Boolean> values) {
            addCriterion("presale in", values, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleNotIn(List<Boolean> values) {
            addCriterion("presale not in", values, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleBetween(Boolean value1, Boolean value2) {
            addCriterion("presale between", value1, value2, "presale");
            return (Criteria) this;
        }

        public Criteria andPresaleNotBetween(Boolean value1, Boolean value2) {
            addCriterion("presale not between", value1, value2, "presale");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceIsNull() {
            addCriterion("predict_ecommerce is null");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceIsNotNull() {
            addCriterion("predict_ecommerce is not null");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceEqualTo(Boolean value) {
            addCriterion("predict_ecommerce =", value, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceNotEqualTo(Boolean value) {
            addCriterion("predict_ecommerce <>", value, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceGreaterThan(Boolean value) {
            addCriterion("predict_ecommerce >", value, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceGreaterThanOrEqualTo(Boolean value) {
            addCriterion("predict_ecommerce >=", value, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceLessThan(Boolean value) {
            addCriterion("predict_ecommerce <", value, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceLessThanOrEqualTo(Boolean value) {
            addCriterion("predict_ecommerce <=", value, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceIn(List<Boolean> values) {
            addCriterion("predict_ecommerce in", values, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceNotIn(List<Boolean> values) {
            addCriterion("predict_ecommerce not in", values, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceBetween(Boolean value1, Boolean value2) {
            addCriterion("predict_ecommerce between", value1, value2, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andPredictEcommerceNotBetween(Boolean value1, Boolean value2) {
            addCriterion("predict_ecommerce not between", value1, value2, "predictEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceIsNull() {
            addCriterion("actual_ecommerce is null");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceIsNotNull() {
            addCriterion("actual_ecommerce is not null");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceEqualTo(Integer value) {
            addCriterion("actual_ecommerce =", value, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceNotEqualTo(Integer value) {
            addCriterion("actual_ecommerce <>", value, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceGreaterThan(Integer value) {
            addCriterion("actual_ecommerce >", value, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceGreaterThanOrEqualTo(Integer value) {
            addCriterion("actual_ecommerce >=", value, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceLessThan(Integer value) {
            addCriterion("actual_ecommerce <", value, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceLessThanOrEqualTo(Integer value) {
            addCriterion("actual_ecommerce <=", value, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceIn(List<Integer> values) {
            addCriterion("actual_ecommerce in", values, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceNotIn(List<Integer> values) {
            addCriterion("actual_ecommerce not in", values, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceBetween(Integer value1, Integer value2) {
            addCriterion("actual_ecommerce between", value1, value2, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andActualEcommerceNotBetween(Integer value1, Integer value2) {
            addCriterion("actual_ecommerce not between", value1, value2, "actualEcommerce");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardIsNull() {
            addCriterion("uploaded_idcard is null");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardIsNotNull() {
            addCriterion("uploaded_idcard is not null");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardEqualTo(Boolean value) {
            addCriterion("uploaded_idcard =", value, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardNotEqualTo(Boolean value) {
            addCriterion("uploaded_idcard <>", value, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardGreaterThan(Boolean value) {
            addCriterion("uploaded_idcard >", value, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardGreaterThanOrEqualTo(Boolean value) {
            addCriterion("uploaded_idcard >=", value, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardLessThan(Boolean value) {
            addCriterion("uploaded_idcard <", value, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardLessThanOrEqualTo(Boolean value) {
            addCriterion("uploaded_idcard <=", value, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardIn(List<Boolean> values) {
            addCriterion("uploaded_idcard in", values, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardNotIn(List<Boolean> values) {
            addCriterion("uploaded_idcard not in", values, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardBetween(Boolean value1, Boolean value2) {
            addCriterion("uploaded_idcard between", value1, value2, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andUploadedIdcardNotBetween(Boolean value1, Boolean value2) {
            addCriterion("uploaded_idcard not between", value1, value2, "uploadedIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardIsNull() {
            addCriterion("need_upload_idcard is null");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardIsNotNull() {
            addCriterion("need_upload_idcard is not null");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardEqualTo(Boolean value) {
            addCriterion("need_upload_idcard =", value, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardNotEqualTo(Boolean value) {
            addCriterion("need_upload_idcard <>", value, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardGreaterThan(Boolean value) {
            addCriterion("need_upload_idcard >", value, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardGreaterThanOrEqualTo(Boolean value) {
            addCriterion("need_upload_idcard >=", value, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardLessThan(Boolean value) {
            addCriterion("need_upload_idcard <", value, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardLessThanOrEqualTo(Boolean value) {
            addCriterion("need_upload_idcard <=", value, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardIn(List<Boolean> values) {
            addCriterion("need_upload_idcard in", values, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardNotIn(List<Boolean> values) {
            addCriterion("need_upload_idcard not in", values, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardBetween(Boolean value1, Boolean value2) {
            addCriterion("need_upload_idcard between", value1, value2, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andNeedUploadIdcardNotBetween(Boolean value1, Boolean value2) {
            addCriterion("need_upload_idcard not between", value1, value2, "needUploadIdcard");
            return (Criteria) this;
        }

        public Criteria andRiskStatusIsNull() {
            addCriterion("risk_status is null");
            return (Criteria) this;
        }

        public Criteria andRiskStatusIsNotNull() {
            addCriterion("risk_status is not null");
            return (Criteria) this;
        }

        public Criteria andRiskStatusEqualTo(Integer value) {
            addCriterion("risk_status =", value, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusNotEqualTo(Integer value) {
            addCriterion("risk_status <>", value, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusGreaterThan(Integer value) {
            addCriterion("risk_status >", value, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusGreaterThanOrEqualTo(Integer value) {
            addCriterion("risk_status >=", value, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusLessThan(Integer value) {
            addCriterion("risk_status <", value, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusLessThanOrEqualTo(Integer value) {
            addCriterion("risk_status <=", value, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusIn(List<Integer> values) {
            addCriterion("risk_status in", values, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusNotIn(List<Integer> values) {
            addCriterion("risk_status not in", values, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusBetween(Integer value1, Integer value2) {
            addCriterion("risk_status between", value1, value2, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andRiskStatusNotBetween(Integer value1, Integer value2) {
            addCriterion("risk_status not between", value1, value2, "riskStatus");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveIsNull() {
            addCriterion("auto_receive is null");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveIsNotNull() {
            addCriterion("auto_receive is not null");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveEqualTo(Boolean value) {
            addCriterion("auto_receive =", value, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveNotEqualTo(Boolean value) {
            addCriterion("auto_receive <>", value, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveGreaterThan(Boolean value) {
            addCriterion("auto_receive >", value, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveGreaterThanOrEqualTo(Boolean value) {
            addCriterion("auto_receive >=", value, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveLessThan(Boolean value) {
            addCriterion("auto_receive <", value, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveLessThanOrEqualTo(Boolean value) {
            addCriterion("auto_receive <=", value, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveIn(List<Boolean> values) {
            addCriterion("auto_receive in", values, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveNotIn(List<Boolean> values) {
            addCriterion("auto_receive not in", values, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveBetween(Boolean value1, Boolean value2) {
            addCriterion("auto_receive between", value1, value2, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andAutoReceiveNotBetween(Boolean value1, Boolean value2) {
            addCriterion("auto_receive not between", value1, value2, "autoReceive");
            return (Criteria) this;
        }

        public Criteria andLockedIsNull() {
            addCriterion("locked is null");
            return (Criteria) this;
        }

        public Criteria andLockedIsNotNull() {
            addCriterion("locked is not null");
            return (Criteria) this;
        }

        public Criteria andLockedEqualTo(Boolean value) {
            addCriterion("locked =", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedNotEqualTo(Boolean value) {
            addCriterion("locked <>", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedGreaterThan(Boolean value) {
            addCriterion("locked >", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("locked >=", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedLessThan(Boolean value) {
            addCriterion("locked <", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedLessThanOrEqualTo(Boolean value) {
            addCriterion("locked <=", value, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedIn(List<Boolean> values) {
            addCriterion("locked in", values, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedNotIn(List<Boolean> values) {
            addCriterion("locked not in", values, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedBetween(Boolean value1, Boolean value2) {
            addCriterion("locked between", value1, value2, "locked");
            return (Criteria) this;
        }

        public Criteria andLockedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("locked not between", value1, value2, "locked");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("deleted is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("deleted is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Boolean value) {
            addCriterion("deleted =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Boolean value) {
            addCriterion("deleted <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Boolean value) {
            addCriterion("deleted >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Boolean value) {
            addCriterion("deleted >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Boolean value) {
            addCriterion("deleted <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Boolean value) {
            addCriterion("deleted <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Boolean> values) {
            addCriterion("deleted in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Boolean> values) {
            addCriterion("deleted not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Boolean value1, Boolean value2) {
            addCriterion("deleted between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Boolean value1, Boolean value2) {
            addCriterion("deleted not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andNewCustomerIsNull() {
            addCriterion("new_customer is null");
            return (Criteria) this;
        }

        public Criteria andNewCustomerIsNotNull() {
            addCriterion("new_customer is not null");
            return (Criteria) this;
        }

        public Criteria andNewCustomerEqualTo(Boolean value) {
            addCriterion("new_customer =", value, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerNotEqualTo(Boolean value) {
            addCriterion("new_customer <>", value, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerGreaterThan(Boolean value) {
            addCriterion("new_customer >", value, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerGreaterThanOrEqualTo(Boolean value) {
            addCriterion("new_customer >=", value, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerLessThan(Boolean value) {
            addCriterion("new_customer <", value, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerLessThanOrEqualTo(Boolean value) {
            addCriterion("new_customer <=", value, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerIn(List<Boolean> values) {
            addCriterion("new_customer in", values, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerNotIn(List<Boolean> values) {
            addCriterion("new_customer not in", values, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerBetween(Boolean value1, Boolean value2) {
            addCriterion("new_customer between", value1, value2, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewCustomerNotBetween(Boolean value1, Boolean value2) {
            addCriterion("new_customer not between", value1, value2, "newCustomer");
            return (Criteria) this;
        }

        public Criteria andNewSellerIsNull() {
            addCriterion("new_seller is null");
            return (Criteria) this;
        }

        public Criteria andNewSellerIsNotNull() {
            addCriterion("new_seller is not null");
            return (Criteria) this;
        }

        public Criteria andNewSellerEqualTo(Boolean value) {
            addCriterion("new_seller =", value, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerNotEqualTo(Boolean value) {
            addCriterion("new_seller <>", value, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerGreaterThan(Boolean value) {
            addCriterion("new_seller >", value, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerGreaterThanOrEqualTo(Boolean value) {
            addCriterion("new_seller >=", value, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerLessThan(Boolean value) {
            addCriterion("new_seller <", value, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerLessThanOrEqualTo(Boolean value) {
            addCriterion("new_seller <=", value, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerIn(List<Boolean> values) {
            addCriterion("new_seller in", values, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerNotIn(List<Boolean> values) {
            addCriterion("new_seller not in", values, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerBetween(Boolean value1, Boolean value2) {
            addCriterion("new_seller between", value1, value2, "newSeller");
            return (Criteria) this;
        }

        public Criteria andNewSellerNotBetween(Boolean value1, Boolean value2) {
            addCriterion("new_seller not between", value1, value2, "newSeller");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNull() {
            addCriterion("cancel_reason is null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIsNotNull() {
            addCriterion("cancel_reason is not null");
            return (Criteria) this;
        }

        public Criteria andCancelReasonEqualTo(String value) {
            addCriterion("cancel_reason =", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotEqualTo(String value) {
            addCriterion("cancel_reason <>", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThan(String value) {
            addCriterion("cancel_reason >", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonGreaterThanOrEqualTo(String value) {
            addCriterion("cancel_reason >=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThan(String value) {
            addCriterion("cancel_reason <", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLessThanOrEqualTo(String value) {
            addCriterion("cancel_reason <=", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonLike(String value) {
            addCriterion("cancel_reason like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotLike(String value) {
            addCriterion("cancel_reason not like", value, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonIn(List<String> values) {
            addCriterion("cancel_reason in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotIn(List<String> values) {
            addCriterion("cancel_reason not in", values, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonBetween(String value1, String value2) {
            addCriterion("cancel_reason between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andCancelReasonNotBetween(String value1, String value2) {
            addCriterion("cancel_reason not between", value1, value2, "cancelReason");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNull() {
            addCriterion("phone is null");
            return (Criteria) this;
        }

        public Criteria andPhoneIsNotNull() {
            addCriterion("phone is not null");
            return (Criteria) this;
        }

        public Criteria andPhoneEqualTo(String value) {
            addCriterion("phone =", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotEqualTo(String value) {
            addCriterion("phone <>", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThan(String value) {
            addCriterion("phone >", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneGreaterThanOrEqualTo(String value) {
            addCriterion("phone >=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThan(String value) {
            addCriterion("phone <", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLessThanOrEqualTo(String value) {
            addCriterion("phone <=", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneLike(String value) {
            addCriterion("phone like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotLike(String value) {
            addCriterion("phone not like", value, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneIn(List<String> values) {
            addCriterion("phone in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotIn(List<String> values) {
            addCriterion("phone not in", values, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneBetween(String value1, String value2) {
            addCriterion("phone between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andPhoneNotBetween(String value1, String value2) {
            addCriterion("phone not between", value1, value2, "phone");
            return (Criteria) this;
        }

        public Criteria andReceiverIsNull() {
            addCriterion("receiver is null");
            return (Criteria) this;
        }

        public Criteria andReceiverIsNotNull() {
            addCriterion("receiver is not null");
            return (Criteria) this;
        }

        public Criteria andReceiverEqualTo(String value) {
            addCriterion("receiver =", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotEqualTo(String value) {
            addCriterion("receiver <>", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverGreaterThan(String value) {
            addCriterion("receiver >", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverGreaterThanOrEqualTo(String value) {
            addCriterion("receiver >=", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverLessThan(String value) {
            addCriterion("receiver <", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverLessThanOrEqualTo(String value) {
            addCriterion("receiver <=", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverLike(String value) {
            addCriterion("receiver like", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotLike(String value) {
            addCriterion("receiver not like", value, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverIn(List<String> values) {
            addCriterion("receiver in", values, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotIn(List<String> values) {
            addCriterion("receiver not in", values, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverBetween(String value1, String value2) {
            addCriterion("receiver between", value1, value2, "receiver");
            return (Criteria) this;
        }

        public Criteria andReceiverNotBetween(String value1, String value2) {
            addCriterion("receiver not between", value1, value2, "receiver");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNull() {
            addCriterion("add_time is null");
            return (Criteria) this;
        }

        public Criteria andAddTimeIsNotNull() {
            addCriterion("add_time is not null");
            return (Criteria) this;
        }

        public Criteria andAddTimeEqualTo(Date value) {
            addCriterion("add_time =", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotEqualTo(Date value) {
            addCriterion("add_time <>", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThan(Date value) {
            addCriterion("add_time >", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("add_time >=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThan(Date value) {
            addCriterion("add_time <", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeLessThanOrEqualTo(Date value) {
            addCriterion("add_time <=", value, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeIn(List<Date> values) {
            addCriterion("add_time in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotIn(List<Date> values) {
            addCriterion("add_time not in", values, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeBetween(Date value1, Date value2) {
            addCriterion("add_time between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andAddTimeNotBetween(Date value1, Date value2) {
            addCriterion("add_time not between", value1, value2, "addTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNull() {
            addCriterion("update_time is null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIsNotNull() {
            addCriterion("update_time is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeEqualTo(Date value) {
            addCriterion("update_time =", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotEqualTo(Date value) {
            addCriterion("update_time <>", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThan(Date value) {
            addCriterion("update_time >", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("update_time >=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThan(Date value) {
            addCriterion("update_time <", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeLessThanOrEqualTo(Date value) {
            addCriterion("update_time <=", value, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeIn(List<Date> values) {
            addCriterion("update_time in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotIn(List<Date> values) {
            addCriterion("update_time not in", values, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeBetween(Date value1, Date value2) {
            addCriterion("update_time between", value1, value2, "updateTime");
            return (Criteria) this;
        }

        public Criteria andUpdateTimeNotBetween(Date value1, Date value2) {
            addCriterion("update_time not between", value1, value2, "updateTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}